﻿CREATE TABLE [Global].[SystemProperty]
(
	[SystemPropertyID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [GLOBAL_SystemProperties] PRIMARY KEY, 
	[PropertyName] NVARCHAR(100) NOT NULL CONSTRAINT [GLOBAL_SystemProperties_PropertyName] UNIQUE,
	[PropertyValue] NVARCHAR(4000) NOT NULL CONSTRAINT [GLOBAL_SystemProperties_PropertyValue] DEFAULT ('NONE'),
	[PropertyDelimiter] NCHAR(1) NULL,
	[PropertyDesc] NVARCHAR(500) NOT NULL CONSTRAINT [GLOBAL_SystemProperties_PropertyDesc] DEFAULT ('NONE'),
	[CreatedBy] NVARCHAR(250) NOT NULL CONSTRAINT [QUEUE_DownloadCreatedBy] DEFAULT SYSTEM_USER,	
	[DateCreated] DATETIME NOT NULL CONSTRAINT [QUEUE_DownloadDateCreated] DEFAULT GETDATE(), 
	[DateDeleted] DATETIME NULL,
	[VersionUser] NVARCHAR(250) NOT NULL CONSTRAINT [QUEUE_DownloadVersionUser] DEFAULT SYSTEM_USER,
	[VersionDate] DATETIME NOT NULL CONSTRAINT [QUEUE_DownloadVersionDate] DEFAULT GETDATE()
)